1 Primary market purchases (38 orders)
primary_ordersGenerally, on each purchase date, they make orders by SAT or PSAT score ranges (SAT if purchasing seniors or juniors, PSAT if purchasing juniors or sophomores):
- Senior purchases by SAT filter
- Sep 2017 (grad class 2018): 4 groups (A, B1, C, D)
- Sep 2018 (grad class 2019): 4 groups (A, B2, C, D)
- Sep 2019 (grad class 2020): 1 group (B3)
- Junior purchases by SAT or PSAT filter
- Sep 2017 (grad class 2019): 3 groups (C1, D, E) - PSAT
- Feb 2018 (grad class 2019): 3 groups (B, C1, D) - PSAT
- Sep 2018 (grad class 2020): 3 groups (C2, D, E) - PSAT
- Feb 2019 (grad class 2020): 4 groups (B, C2, D, E) - PSAT
- Sep 2019 (grad class 2021): 1 group (B3) - SAT
- Apr 2020 (grad class 2021): 1 group (B3) - SAT
- Sophomore purchases by PSAT filter
- Sep 2017 (grad class 2020): 2 groups (B, E)
- Feb 2018 (grad class 2020): 4 groups (A, B, C1, D)
- Sep 2018 (grad class 2021): 3 groups (C2, D, E)
- Feb 2019 (grad class 2021): 4 groups (B, C2, D, E)
- Sep 2019 (grad class 2022): 1 group (C3)
distinct(primary_orders %>% select(sat_score_min, sat_score_max, psat_score_min, psat_score_max)) %>%
arrange(sat_score_min, sat_score_max, psat_score_min, psat_score_max) %>%
add_column(score_range = c('A', 'B1', 'B2', 'B3', 'C', 'D', 'A', 'B', 'C1', 'C2', 'C3', 'D', 'E'), .before = 1)Common filters:
- GPA: A+ to C+
General observations:
- Only purchase seniors during the Fall, and juniors and sophomores both Fall & Spring
- For juniors and sophomores, Spring purchases generally have lower test score ranges than Fall purchases
- Over the years, there is a slight increase in some test score ranges for all grad classes
- Usually making multiple orders at a time w/ different test score ranges, but starting in 2019, only made 1 order covering broader score range for all grad classes
- Also, started using SAT instead of PSAT filter for sophomores
